﻿CREATE PROCEDURE [dbo].[sp_Get_MailAddresses]
	@type int
AS
	SELECT [Email] FROM [dbo].[Accounts] WHERE AccountType = @type and [Status] = 0